import pandas as pd
import numpy as np
from datetime import datetime, timedelta
import seaborn as sns
import matplotlib.pyplot as plt
%matplotlib inline
import plotly.graph_objects as go
#file = pd.read_csv(r"https://raw.githubusercontent.com/logpai/loghub/master/HealthApp/HealthApp_2k.log_structured.csv")
file = pd.read_csv(r"D:\WORKOOPOLIS\NATWEST\HealthApp_2k.log_structured.csv")
file
| LineId | Time | Component | Pid | Content | EventId | EventTemplate | |
|---|---|---|---|---|---|---|---|
| 0 | 1 | 20171223-22:15:29:606 | Step_LSC | 30002312 | onStandStepChanged 3579 | E42 | onStandStepChanged <*> |
| 1 | 2 | 20171223-22:15:29:615 | Step_LSC | 30002312 | onExtend:1514038530000 14 0 4 | E39 | onExtend:<*> <*> <*> <*> |
| 2 | 3 | 20171223-22:15:29:633 | Step_StandReportReceiver | 30002312 | onReceive action: android.intent.action.SCREEN_ON | E41 | onReceive action: android.intent.action.SCREEN_ON |
| 3 | 4 | 20171223-22:15:29:635 | Step_LSC | 30002312 | processHandleBroadcastAction action:android.in... | E43 | processHandleBroadcastAction action:android.in... |
| 4 | 5 | 20171223-22:15:29:635 | Step_StandStepCounter | 30002312 | flush sensor data | E12 | flush sensor data |
| ... | ... | ... | ... | ... | ... | ... | ... |
| 1995 | 1996 | 20171224-0:58:53:985 | Step_LSC | 30002312 | processHandleBroadcastAction action:android.in... | E44 | processHandleBroadcastAction action:android.in... |
| 1996 | 1997 | 20171224-0:59:7:581 | Step_LSC | 30002312 | processHandleBroadcastAction action:android.in... | E44 | processHandleBroadcastAction action:android.in... |
| 1997 | 1998 | 20171224-1:0:0:794 | Step_LSC | 30002312 | processHandleBroadcastAction action:android.in... | E44 | processHandleBroadcastAction action:android.in... |
| 1998 | 1999 | 20171224-1:1:0:935 | Step_LSC | 30002312 | processHandleBroadcastAction action:android.in... | E44 | processHandleBroadcastAction action:android.in... |
| 1999 | 2000 | 20171224-1:2:35:789 | Step_LSC | 30002312 | processHandleBroadcastAction action:android.in... | E44 | processHandleBroadcastAction action:android.in... |
2000 rows × 7 columns
file['Time1'] = file['Time'].str.split('-').str.get(0)
file['Time1'] = pd.to_datetime(file['Time1'])
file['year'] = file['Time1'].dt.year
file['month'] = file['Time1'].dt.month
file['day'] = file['Time1'].dt.day
#file['week'] = file['Time1'].dt.weekofyear
file1 = file.drop(['Time'], axis=1)
file['Time2'] = file['Time'].str.split('-').str.get(1)
file['hour'] = file['Time2'].str.split(':').str.get(0)
file['minutes'] = file['Time2'].str.split(':').str.get(1)
file['seconds'] = file['Time2'].str.split(':').str.get(2)
file['Time2'] = pd.to_datetime(file['Time2'], format='%H:%M:%S:%f', errors='coerce')
file['hour_minute'] = file['Time2'].dt.strftime('%H:%M')
file1 = file.drop(['Time1','Time2'], axis=1)
file1['Component'].value_counts()
Component Step_LSC 710 Step_SPUtils 494 Step_ExtSDM 482 Step_StandReportReceiver 171 HiH_HiSyncControl 42 Step_StandStepCounter 19 HiH_DataStatManager 17 HiH_HiHealthDataInsertStore 11 HiH_ 10 HiH_HiHealthBinder 9 HiH_HiAppUtil 8 Step_FlushableStepDataCache 8 HiH_HiBroadcastUtil 5 Step_StandStepDataManager 5 HiH_ListenerManager 2 HiH_HiSyncUtil 2 Step_HGNH 2 Step_ScreenUtil 1 Step_DataCache 1 Step_NotificationUtil 1 Name: count, dtype: int64
list(file1['Content'])
['onStandStepChanged 3579',
'onExtend:1514038530000 14 0 4',
'onReceive action: android.intent.action.SCREEN_ON',
'processHandleBroadcastAction action:android.intent.action.SCREEN_ON',
'flush sensor data',
' getTodayTotalDetailSteps = 1514038440000##6993##548365##8661##12266##27164404',
'setTodayTotalDetailSteps=1514038440000##7007##548365##8661##12361##27173954',
'onStandStepChanged 3579',
'calculateCaloriesWithCache totalCalories=126775',
'calculateAltitudeWithCache totalAltitude=240',
'REPORT : 7007 5002 150089 240',
'onExtend:1514038530000 0 0 4',
'onStandStepChanged 3579',
'onStandStepChanged 3580',
'onExtend:1514038530000 1 0 4',
' getTodayTotalDetailSteps = 1514038440000##7007##548365##8661##12361##27173954',
'setTodayTotalDetailSteps=1514038440000##7008##548365##8661##12456##27174269',
'calculateCaloriesWithCache totalCalories=126797',
'calculateAltitudeWithCache totalAltitude=240',
'REPORT : 7008 5003 150111 240',
'onStandStepChanged 3581',
'onExtend:1514038531000 1 0 4',
' getTodayTotalDetailSteps = 1514038440000##7008##548365##8661##12456##27174269',
'setTodayTotalDetailSteps=1514038440000##7009##548365##8661##12551##27174951',
'calculateCaloriesWithCache totalCalories=126818',
'calculateAltitudeWithCache totalAltitude=240',
'REPORT : 7009 5004 150132 240',
'onStandStepChanged 3583',
'onExtend:1514038531000 2 0 4',
' getTodayTotalDetailSteps = 1514038440000##7009##548365##8661##12551##27174951',
'setTodayTotalDetailSteps=1514038440000##7011##548365##8661##12646##27175461',
'calculateCaloriesWithCache totalCalories=126861',
'calculateAltitudeWithCache totalAltitude=240',
'REPORT : 7011 5005 150175 240',
'onStandStepChanged 3584',
'onExtend:1514038532000 1 0 4',
' getTodayTotalDetailSteps = 1514038440000##7011##548365##8661##12646##27175461',
'setTodayTotalDetailSteps=1514038440000##7012##548365##8661##12741##27176464',
'calculateCaloriesWithCache totalCalories=126882',
'calculateAltitudeWithCache totalAltitude=240',
'REPORT : 7012 5006 150197 240',
'onStandStepChanged 3585',
'onExtend:1514038533000 1 0 4',
' getTodayTotalDetailSteps = 1514038440000##7012##548365##8661##12741##27176464',
'setTodayTotalDetailSteps=1514038440000##7013##548365##8661##12836##27176966',
'calculateCaloriesWithCache totalCalories=126904',
'calculateAltitudeWithCache totalAltitude=240',
'REPORT : 7013 5007 150218 240',
'onStandStepChanged 3586',
'onExtend:1514038533000 1 0 4',
' getTodayTotalDetailSteps = 1514038440000##7013##548365##8661##12836##27176966',
'setTodayTotalDetailSteps=1514038440000##7014##548365##8661##12931##27177463',
'calculateCaloriesWithCache totalCalories=126925',
'calculateAltitudeWithCache totalAltitude=240',
'REPORT : 7014 5007 150239 240',
'onStandStepChanged 3587',
'onExtend:1514038534000 1 0 4',
' getTodayTotalDetailSteps = 1514038440000##7014##548365##8661##12931##27177463',
'setTodayTotalDetailSteps=1514038440000##7015##548365##8661##13026##27177962',
'calculateCaloriesWithCache totalCalories=126947',
'calculateAltitudeWithCache totalAltitude=240',
'REPORT : 7015 5008 150261 240',
'onStandStepChanged 3588',
'onExtend:1514038535000 1 0 4',
'onReceive action: android.intent.action.SCREEN_OFF',
'onStandStepChanged 3589',
'onExtend:1514038535000 1 0 4',
' getTodayTotalDetailSteps = 1514038440000##7015##548365##8661##13026##27177962',
'setTodayTotalDetailSteps=1514038440000##7017##548365##8661##13121##27179330',
'calculateCaloriesWithCache totalCalories=126989',
'calculateAltitudeWithCache totalAltitude=240',
'isScreenOn true',
'screen status unknown,think screen on',
'REPORT : 7017 5010 150304 240',
'onReceive action: android.intent.action.SCREEN_ON',
'processHandleBroadcastAction action:android.intent.action.SCREEN_ON',
'flush sensor data',
' getTodayTotalDetailSteps = 1514038440000##7017##548365##8661##13121##27179330',
'setTodayTotalDetailSteps=1514038440000##7017##548365##8661##13216##27179417',
'onStandStepChanged 3589',
'calculateCaloriesWithCache totalCalories=126989',
'calculateAltitudeWithCache totalAltitude=240',
'REPORT : 7017 5010 150304 240',
'onStandStepChanged 3589',
'onExtend:1514038536000 0 0 4',
'onStandStepChanged 3590',
'onExtend:1514038536000 1 0 4',
' getTodayTotalDetailSteps = 1514038440000##7017##548365##8661##13216##27179417',
'setTodayTotalDetailSteps=1514038440000##7018##548365##8661##13311##27179732',
'calculateCaloriesWithCache totalCalories=127011',
'calculateAltitudeWithCache totalAltitude=240',
'REPORT : 7018 5010 150325 240',
'onStandStepChanged 3591',
'onExtend:1514038536000 1 0 4',
' getTodayTotalDetailSteps = 1514038440000##7018##548365##8661##13311##27179732',
'setTodayTotalDetailSteps=1514038440000##7019##548365##8661##13406##27180468',
'calculateCaloriesWithCache totalCalories=127032',
'calculateAltitudeWithCache totalAltitude=240',
'REPORT : 7019 5011 150346 240',
'onStandStepChanged 3592',
'onExtend:1514038537000 1 0 4',
' getTodayTotalDetailSteps = 1514038440000##7019##548365##8661##13406##27180468',
'setTodayTotalDetailSteps=1514038440000##7020##548365##8661##13501##27180976',
'calculateCaloriesWithCache totalCalories=127054',
'calculateAltitudeWithCache totalAltitude=240',
'REPORT : 7020 5012 150368 240',
'onStandStepChanged 3593',
'onExtend:1514038538000 1 0 4',
' getTodayTotalDetailSteps = 1514038440000##7020##548365##8661##13501##27180976',
'setTodayTotalDetailSteps=1514038440000##7021##548365##8661##13596##27181971',
'calculateCaloriesWithCache totalCalories=127075',
'calculateAltitudeWithCache totalAltitude=240',
'REPORT : 7021 5012 150389 240',
'onStandStepChanged 3594',
'onExtend:1514038538000 1 0 4',
' getTodayTotalDetailSteps = 1514038440000##7021##548365##8661##13596##27181971',
'setTodayTotalDetailSteps=1514038440000##7022##548365##8661##13691##27182468',
'calculateCaloriesWithCache totalCalories=127097',
'calculateAltitudeWithCache totalAltitude=240',
'REPORT : 7022 5013 150411 240',
'onStandStepChanged 3595',
'onExtend:1514038539000 1 0 4',
' getTodayTotalDetailSteps = 1514038440000##7022##548365##8661##13691##27182468',
'setTodayTotalDetailSteps=1514038440000##7023##548365##8661##13786##27182973',
'calculateCaloriesWithCache totalCalories=127118',
'calculateAltitudeWithCache totalAltitude=240',
'REPORT : 7023 5014 150432 240',
'onStandStepChanged 3596',
'onExtend:1514038539000 1 0 4',
' getTodayTotalDetailSteps = 1514038440000##7023##548365##8661##13786##27182973',
'setTodayTotalDetailSteps=1514038440000##7024##548365##8661##13881##27183469',
'calculateCaloriesWithCache totalCalories=127139',
'calculateAltitudeWithCache totalAltitude=240',
'REPORT : 7024 5015 150454 240',
'onStandStepChanged 3597',
'onExtend:1514038540000 1 0 4',
' getTodayTotalDetailSteps = 1514038440000##7024##548365##8661##13881##27183469',
'setTodayTotalDetailSteps=1514038440000##7025##548365##8661##13976##27183974',
'calculateCaloriesWithCache totalCalories=127161',
'calculateAltitudeWithCache totalAltitude=240',
'REPORT : 7025 5015 150475 240',
'onStandStepChanged 3598',
'onExtend:1514038541000 1 0 4',
' getTodayTotalDetailSteps = 1514038440000##7025##548365##8661##13976##27183974',
'setTodayTotalDetailSteps=1514038440000##7026##548365##8661##14071##27184972',
'calculateCaloriesWithCache totalCalories=127182',
'calculateAltitudeWithCache totalAltitude=240',
'REPORT : 7026 5016 150496 240',
'onStandStepChanged 3599',
'onExtend:1514038541000 1 0 4',
' getTodayTotalDetailSteps = 1514038440000##7026##548365##8661##14071##27184972',
'setTodayTotalDetailSteps=1514038440000##7027##548365##8661##14166##27185467',
'calculateCaloriesWithCache totalCalories=127204',
'calculateAltitudeWithCache totalAltitude=240',
'REPORT : 7027 5017 150518 240',
'onStandStepChanged 3600',
'onExtend:1514038542000 1 0 4',
' getTodayTotalDetailSteps = 1514038440000##7027##548365##8661##14166##27185467',
'setTodayTotalDetailSteps=1514038440000##7028##548365##8661##14261##27185977',
'calculateCaloriesWithCache totalCalories=127225',
'calculateAltitudeWithCache totalAltitude=240',
'REPORT : 7028 5017 150539 240',
'onStandStepChanged 3601',
'onExtend:1514038542000 1 0 4',
' getTodayTotalDetailSteps = 1514038440000##7028##548365##8661##14261##27185977',
'setTodayTotalDetailSteps=1514038440000##7029##548365##8661##14356##27186469',
'calculateCaloriesWithCache totalCalories=127246',
'calculateAltitudeWithCache totalAltitude=240',
'REPORT : 7029 5018 150561 240',
'onStandStepChanged 3602',
'onExtend:1514038543000 1 0 4',
' getTodayTotalDetailSteps = 1514038440000##7029##548365##8661##14356##27186469',
'setTodayTotalDetailSteps=1514038440000##7030##548365##8661##14451##27187468',
'calculateCaloriesWithCache totalCalories=127268',
'calculateAltitudeWithCache totalAltitude=240',
'REPORT : 7030 5019 150582 240',
'onStandStepChanged 3603',
'onExtend:1514038544000 1 0 4',
' getTodayTotalDetailSteps = 1514038440000##7030##548365##8661##14451##27187468',
'setTodayTotalDetailSteps=1514038440000##7031##548365##8661##14546##27187968',
'calculateCaloriesWithCache totalCalories=127289',
'calculateAltitudeWithCache totalAltitude=240',
'REPORT : 7031 5020 150604 240',
'onStandStepChanged 3604',
'onExtend:1514038544000 1 0 4',
' getTodayTotalDetailSteps = 1514038440000##7031##548365##8661##14546##27187968',
'setTodayTotalDetailSteps=1514038440000##7032##548365##8661##14641##27188471',
'calculateCaloriesWithCache totalCalories=127311',
'calculateAltitudeWithCache totalAltitude=240',
'REPORT : 7032 5020 150625 240',
'onStandStepChanged 3605',
'onExtend:1514038545000 1 0 4',
' getTodayTotalDetailSteps = 1514038440000##7032##548365##8661##14641##27188471',
'setTodayTotalDetailSteps=1514038440000##7033##548365##8661##14736##27189469',
'calculateCaloriesWithCache totalCalories=127332',
'calculateAltitudeWithCache totalAltitude=240',
'REPORT : 7033 5021 150646 240',
'onStandStepChanged 3606',
'onExtend:1514038546000 1 0 4',
' getTodayTotalDetailSteps = 1514038440000##7033##548365##8661##14736##27189469',
'setTodayTotalDetailSteps=1514038440000##7034##548365##8661##14831##27189969',
'calculateCaloriesWithCache totalCalories=127354',
'calculateAltitudeWithCache totalAltitude=240',
'REPORT : 7034 5022 150668 240',
'onStandStepChanged 3607',
'onExtend:1514038546000 1 0 4',
' getTodayTotalDetailSteps = 1514038440000##7034##548365##8661##14831##27189969',
'setTodayTotalDetailSteps=1514038440000##7035##548365##8661##14926##27190469',
'calculateCaloriesWithCache totalCalories=127375',
'calculateAltitudeWithCache totalAltitude=240',
'REPORT : 7035 5022 150689 240',
'onStandStepChanged 3608',
'onExtend:1514038547000 1 0 4',
' getTodayTotalDetailSteps = 1514038440000##7035##548365##8661##14926##27190469',
'setTodayTotalDetailSteps=1514038440000##7036##548365##8661##15021##27190970',
'calculateCaloriesWithCache totalCalories=127396',
'calculateAltitudeWithCache totalAltitude=240',
'REPORT : 7036 5023 150711 240',
'onStandStepChanged 3609',
'onExtend:1514038548000 1 0 4',
' getTodayTotalDetailSteps = 1514038440000##7036##548365##8661##15021##27190970',
'setTodayTotalDetailSteps=1514038440000##7037##548365##8661##15116##27191969',
'calculateCaloriesWithCache totalCalories=127418',
'calculateAltitudeWithCache totalAltitude=240',
'REPORT : 7037 5024 150732 240',
'onStandStepChanged 3610',
'onExtend:1514038548000 1 0 4',
' getTodayTotalDetailSteps = 1514038440000##7037##548365##8661##15116##27191969',
'setTodayTotalDetailSteps=1514038440000##7038##548365##8661##15211##27192478',
'calculateCaloriesWithCache totalCalories=127439',
'calculateAltitudeWithCache totalAltitude=240',
'REPORT : 7038 5025 150753 240',
'onStandStepChanged 3611',
'onExtend:1514038549000 1 0 4',
' getTodayTotalDetailSteps = 1514038440000##7038##548365##8661##15211##27192478',
'setTodayTotalDetailSteps=1514038440000##7039##548365##8661##15306##27192971',
'calculateCaloriesWithCache totalCalories=127461',
'calculateAltitudeWithCache totalAltitude=240',
'REPORT : 7039 5025 150775 240',
'onStandStepChanged 3612',
'onExtend:1514038550000 1 0 4',
' getTodayTotalDetailSteps = 1514038440000##7039##548365##8661##15306##27192971',
'setTodayTotalDetailSteps=1514038440000##7040##548365##8661##15401##27193971',
'calculateCaloriesWithCache totalCalories=127482',
'calculateAltitudeWithCache totalAltitude=240',
'REPORT : 7040 5026 150796 240',
'onStandStepChanged 3613',
'onExtend:1514038550000 1 0 4',
' getTodayTotalDetailSteps = 1514038440000##7040##548365##8661##15401##27193971',
'setTodayTotalDetailSteps=1514038440000##7041##548365##8661##15496##27194480',
'calculateCaloriesWithCache totalCalories=127504',
'calculateAltitudeWithCache totalAltitude=240',
'REPORT : 7041 5027 150818 240',
'onStandStepChanged 3614',
'onExtend:1514038551000 1 0 4',
' getTodayTotalDetailSteps = 1514038440000##7041##548365##8661##15496##27194480',
'setTodayTotalDetailSteps=1514038440000##7042##548365##8661##15591##27195470',
'calculateCaloriesWithCache totalCalories=127525',
'calculateAltitudeWithCache totalAltitude=240',
'REPORT : 7042 5027 150839 240',
'onStandStepChanged 3616',
'onExtend:1514038552000 2 0 4',
' getTodayTotalDetailSteps = 1514038440000##7042##548365##8661##15591##27195470',
'setTodayTotalDetailSteps=1514038440000##7044##548365##8661##15686##27196480',
'calculateCaloriesWithCache totalCalories=127568',
'calculateAltitudeWithCache totalAltitude=240',
'REPORT : 7044 5029 150882 240',
'onStandStepChanged 3617',
'onExtend:1514038553000 1 0 4',
' getTodayTotalDetailSteps = 1514038440000##7044##548365##8661##15686##27196480',
'setTodayTotalDetailSteps=1514038440000##7045##548365##8661##15781##27196970',
'calculateCaloriesWithCache totalCalories=127589',
'calculateAltitudeWithCache totalAltitude=240',
'REPORT : 7045 5030 150903 240',
'onStandStepChanged 3619',
'onExtend:1514038554000 2 0 4',
' getTodayTotalDetailSteps = 1514038440000##7045##548365##8661##15781##27196970',
'setTodayTotalDetailSteps=1514038440000##7047##548365##8661##15876##27197972',
'calculateCaloriesWithCache totalCalories=127632',
'calculateAltitudeWithCache totalAltitude=240',
'REPORT : 7047 5031 150946 240',
'onStandStepChanged 3620',
'onExtend:1514038555000 1 0 4',
' getTodayTotalDetailSteps = 1514038440000##7047##548365##8661##15876##27197972',
'setTodayTotalDetailSteps=1514038440000##7048##548365##8661##15971##27198970',
'calculateCaloriesWithCache totalCalories=127653',
'calculateAltitudeWithCache totalAltitude=240',
'REPORT : 7048 5032 150968 240',
'onStandStepChanged 3622',
'onExtend:1514038556000 2 0 4',
' getTodayTotalDetailSteps = 1514038440000##7048##548365##8661##15971##27198970',
'setTodayTotalDetailSteps=1514038440000##7050##548365##8661##16066##27199969',
'calculateCaloriesWithCache totalCalories=127696',
'calculateAltitudeWithCache totalAltitude=240',
'REPORT : 7050 5033 151011 240',
'onStandStepChanged 3624',
'onExtend:1514038556000 2 0 4',
' getTodayTotalDetailSteps = 1514038440000##7050##548365##8661##16066##27199969',
'setTodayTotalDetailSteps=1514038440000##7052##548365##8661##16161##27200470',
'calculateCaloriesWithCache totalCalories=127739',
'calculateAltitudeWithCache totalAltitude=240',
'REPORT : 7052 5035 151053 240',
'onStandStepChanged 3625',
'onExtend:1514038558000 1 0 4',
' getTodayTotalDetailSteps = 1514038440000##7052##548365##8661##16161##27200470',
'setTodayTotalDetailSteps=1514038440000##7053##548365##8661##16256##27202475',
'calculateCaloriesWithCache totalCalories=127761',
'calculateAltitudeWithCache totalAltitude=240',
'REPORT : 7053 5035 151075 240',
'onStandStepChanged 3626',
'onExtend:1514038560000 1 0 4',
'processHandleBroadcastAction action:android.intent.action.TIME_TICK',
' getTodayTotalDetailSteps = 1514038440000##7053##548365##8661##16256##27202475',
'setTodayTotalDetailSteps=1514038500000##7054##548458##8661##16256##27204469',
'calculateCaloriesWithCache totalCalories=127782',
'calculateAltitudeWithCache totalAltitude=240',
'REPORT : 7054 5036 151096 240',
'onStandStepChanged 3626',
'onExtend:1514038561000 0 0 0',
' getTodayTotalDetailSteps = 1514038500000##7054##548458##8661##16256##27204469',
'setTodayTotalDetailSteps=1514038500000##7054##548551##8661##16256##27205469',
'calculateCaloriesWithCache totalCalories=127782',
'calculateAltitudeWithCache totalAltitude=240',
'processHandleBroadcastAction action:android.intent.action.TIME_TICK',
'onStandStepChanged 3626',
'onExtend:1514038639000 0 0 4',
' getTodayTotalDetailSteps = 1514038500000##7054##548551##8661##16256##27205469',
'setTodayTotalDetailSteps=1514038560000##7054##548552##8661##16256##27283470',
'calculateCaloriesWithCache totalCalories=127782',
'calculateAltitudeWithCache totalAltitude=240',
'onStandStepChanged 3628',
'onExtend:1514038641000 2 0 4',
' getTodayTotalDetailSteps = 1514038560000##7054##548552##8661##16256##27283470',
'setTodayTotalDetailSteps=1514038560000##7056##548553##8661##16256##27284971',
'calculateCaloriesWithCache totalCalories=127824',
'calculateAltitudeWithCache totalAltitude=240',
'REPORT : 7056 5037 151139 240',
'onStandStepChanged 3630',
'onExtend:1514038641000 2 0 4',
' getTodayTotalDetailSteps = 1514038560000##7056##548553##8661##16256##27284971',
'setTodayTotalDetailSteps=1514038560000##7058##548554##8661##16256##27285475',
'calculateCaloriesWithCache totalCalories=127867',
'calculateAltitudeWithCache totalAltitude=240',
'REPORT : 7058 5039 151182 240',
'onStandStepChanged 3632',
'onExtend:1514038642000 2 0 4',
' getTodayTotalDetailSteps = 1514038560000##7058##548554##8661##16256##27285475',
'setTodayTotalDetailSteps=1514038560000##7060##548555##8661##16256##27285968',
'calculateCaloriesWithCache totalCalories=127910',
'calculateAltitudeWithCache totalAltitude=240',
'REPORT : 7060 5040 151225 240',
'onStandStepChanged 3634',
'onExtend:1514038642000 2 0 4',
' getTodayTotalDetailSteps = 1514038560000##7060##548555##8661##16256##27285968',
'setTodayTotalDetailSteps=1514038560000##7062##548556##8661##16256##27286470',
'calculateCaloriesWithCache totalCalories=127953',
'calculateAltitudeWithCache totalAltitude=240',
'REPORT : 7062 5042 151268 240',
'onStandStepChanged 3636',
'onExtend:1514038643000 2 0 4',
' getTodayTotalDetailSteps = 1514038560000##7062##548556##8661##16256##27286470',
'setTodayTotalDetailSteps=1514038560000##7064##548557##8661##16256##27286970',
'calculateCaloriesWithCache totalCalories=127996',
'calculateAltitudeWithCache totalAltitude=240',
'REPORT : 7064 5043 151310 240',
'onStandStepChanged 3638',
'onExtend:1514038643000 2 0 4',
' getTodayTotalDetailSteps = 1514038560000##7064##548557##8661##16256##27286970',
'setTodayTotalDetailSteps=1514038560000##7066##548558##8661##16256##27287469',
'calculateCaloriesWithCache totalCalories=128039',
'calculateAltitudeWithCache totalAltitude=240',
'REPORT : 7066 5045 151353 240',
'onStandStepChanged 3640',
'onExtend:1514038644000 2 0 4',
' getTodayTotalDetailSteps = 1514038560000##7066##548558##8661##16256##27287469',
'setTodayTotalDetailSteps=1514038560000##7068##548559##8661##16256##27287972',
'calculateCaloriesWithCache totalCalories=128081',
'calculateAltitudeWithCache totalAltitude=240',
'REPORT : 7068 5046 151396 240',
'onStandStepChanged 3642',
'onExtend:1514038644000 2 0 4',
' getTodayTotalDetailSteps = 1514038560000##7068##548559##8661##16256##27287972',
'setTodayTotalDetailSteps=1514038560000##7070##548560##8661##16256##27288471',
'calculateCaloriesWithCache totalCalories=128124',
'calculateAltitudeWithCache totalAltitude=240',
'REPORT : 7070 5047 151439 240',
'onStandStepChanged 3643',
'onExtend:1514038645000 1 0 4',
' getTodayTotalDetailSteps = 1514038560000##7070##548560##8661##16256##27288471',
'setTodayTotalDetailSteps=1514038560000##7071##548561##8661##16256##27288973',
'calculateCaloriesWithCache totalCalories=128146',
'calculateAltitudeWithCache totalAltitude=240',
'REPORT : 7071 5048 151460 240',
'onStandStepChanged 3646',
'onExtend:1514038645000 3 0 4',
' getTodayTotalDetailSteps = 1514038560000##7071##548561##8661##16256##27288973',
'setTodayTotalDetailSteps=1514038560000##7074##548562##8661##16256##27289470',
'calculateCaloriesWithCache totalCalories=128210',
'calculateAltitudeWithCache totalAltitude=240',
'REPORT : 7074 5050 151525 240',
'onStandStepChanged 3646',
'onExtend:1514038648000 0 0 0',
' getTodayTotalDetailSteps = 1514038560000##7074##548562##8661##16256##27289470',
'setTodayTotalDetailSteps=1514038560000##7074##548563##8661##16256##27292475',
'calculateCaloriesWithCache totalCalories=128210',
'calculateAltitudeWithCache totalAltitude=240',
'onStandStepChanged 3647',
'onExtend:1514038665000 1 0 4',
' getTodayTotalDetailSteps = 1514038560000##7074##548563##8661##16256##27292475',
'setTodayTotalDetailSteps=1514038560000##7075##548564##8661##16256##27309470',
'calculateCaloriesWithCache totalCalories=128231',
'calculateAltitudeWithCache totalAltitude=240',
'REPORT : 7075 5051 151546 240',
'onStandStepChanged 3649',
'onExtend:1514038666000 2 0 4',
' getTodayTotalDetailSteps = 1514038560000##7075##548564##8661##16256##27309470',
'setTodayTotalDetailSteps=1514038560000##7077##548565##8661##16256##27309969',
'calculateCaloriesWithCache totalCalories=128274',
'calculateAltitudeWithCache totalAltitude=240',
'REPORT : 7077 5052 151589 240',
'onStandStepChanged 3651',
'onExtend:1514038666000 2 0 4',
' getTodayTotalDetailSteps = 1514038560000##7077##548565##8661##16256##27309969',
'setTodayTotalDetailSteps=1514038560000##7079##548566##8661##16256##27310473',
'calculateCaloriesWithCache totalCalories=128317',
'calculateAltitudeWithCache totalAltitude=240',
'REPORT : 7079 5054 151632 240',
'onStandStepChanged 3653',
'onExtend:1514038667000 2 0 4',
' getTodayTotalDetailSteps = 1514038560000##7079##548566##8661##16256##27310473',
'setTodayTotalDetailSteps=1514038560000##7081##548567##8661##16256##27310970',
'calculateCaloriesWithCache totalCalories=128360',
'calculateAltitudeWithCache totalAltitude=240',
'REPORT : 7081 5055 151675 240',
'onStandStepChanged 3655',
'onExtend:1514038667000 2 0 4',
' getTodayTotalDetailSteps = 1514038560000##7081##548567##8661##16256##27310970',
'setTodayTotalDetailSteps=1514038560000##7083##548568##8661##16256##27311472',
'calculateCaloriesWithCache totalCalories=128403',
'calculateAltitudeWithCache totalAltitude=240',
'REPORT : 7083 5057 151717 240',
'onStandStepChanged 3656',
'onExtend:1514038668000 1 0 4',
' getTodayTotalDetailSteps = 1514038560000##7083##548568##8661##16256##27311472',
'setTodayTotalDetailSteps=1514038560000##7084##548569##8661##16256##27311970',
'calculateCaloriesWithCache totalCalories=128424',
'calculateAltitudeWithCache totalAltitude=240',
'REPORT : 7084 5057 151739 240',
'onStandStepChanged 3658',
'onExtend:1514038668000 2 0 4',
' getTodayTotalDetailSteps = 1514038560000##7084##548569##8661##16256##27311970',
'setTodayTotalDetailSteps=1514038560000##7086##548570##8661##16256##27312467',
'calculateCaloriesWithCache totalCalories=128467',
'calculateAltitudeWithCache totalAltitude=240',
'REPORT : 7086 5059 151782 240',
'onStandStepChanged 3660',
'onExtend:1514038669000 2 0 4',
' getTodayTotalDetailSteps = 1514038560000##7086##548570##8661##16256##27312467',
'setTodayTotalDetailSteps=1514038560000##7088##548571##8661##16256##27312967',
'calculateCaloriesWithCache totalCalories=128510',
'calculateAltitudeWithCache totalAltitude=240',
'REPORT : 7088 5060 151824 240',
'onStandStepChanged 3662',
'onExtend:1514038669000 2 0 4',
' getTodayTotalDetailSteps = 1514038560000##7088##548571##8661##16256##27312967',
'setTodayTotalDetailSteps=1514038560000##7090##548572##8661##16256##27313468',
'calculateCaloriesWithCache totalCalories=128553',
'calculateAltitudeWithCache totalAltitude=240',
'REPORT : 7090 5062 151867 240',
'onStandStepChanged 3664',
'onExtend:1514038670000 2 0 4',
' getTodayTotalDetailSteps = 1514038560000##7090##548572##8661##16256##27313468',
'setTodayTotalDetailSteps=1514038560000##7092##548573##8661##16256##27313974',
'calculateCaloriesWithCache totalCalories=128595',
'calculateAltitudeWithCache totalAltitude=240',
'REPORT : 7092 5063 151910 240',
'onStandStepChanged 3666',
'onExtend:1514038670000 2 0 4',
' getTodayTotalDetailSteps = 1514038560000##7092##548573##8661##16256##27313974',
'setTodayTotalDetailSteps=1514038560000##7094##548574##8661##16256##27314468',
'calculateCaloriesWithCache totalCalories=128638',
'calculateAltitudeWithCache totalAltitude=240',
'REPORT : 7094 5065 151953 240',
'onStandStepChanged 3667',
'onExtend:1514038671000 1 0 4',
' getTodayTotalDetailSteps = 1514038560000##7094##548574##8661##16256##27314468',
'setTodayTotalDetailSteps=1514038560000##7095##548575##8661##16256##27314968',
'calculateCaloriesWithCache totalCalories=128660',
'calculateAltitudeWithCache totalAltitude=240',
'REPORT : 7095 5065 151974 240',
'onStandStepChanged 3669',
'onExtend:1514038671000 2 0 4',
' getTodayTotalDetailSteps = 1514038560000##7095##548575##8661##16256##27314968',
'setTodayTotalDetailSteps=1514038560000##7097##548576##8661##16256##27315469',
'calculateCaloriesWithCache totalCalories=128703',
'calculateAltitudeWithCache totalAltitude=240',
'REPORT : 7097 5067 152017 240',
'onStandStepChanged 3671',
'onExtend:1514038672000 2 0 4',
' getTodayTotalDetailSteps = 1514038560000##7097##548576##8661##16256##27315469',
'setTodayTotalDetailSteps=1514038560000##7099##548577##8661##16256##27315983',
'calculateCaloriesWithCache totalCalories=128745',
'calculateAltitudeWithCache totalAltitude=240',
'REPORT : 7099 5068 152060 240',
'onStandStepChanged 3673',
'onExtend:1514038672000 2 0 4',
' getTodayTotalDetailSteps = 1514038560000##7099##548577##8661##16256##27315983',
'setTodayTotalDetailSteps=1514038560000##7101##548578##8661##16256##27316470',
'calculateCaloriesWithCache totalCalories=128788',
'calculateAltitudeWithCache totalAltitude=240',
'REPORT : 7101 5070 152103 240',
'onStandStepChanged 3674',
'onExtend:1514038673000 1 0 4',
' getTodayTotalDetailSteps = 1514038560000##7101##548578##8661##16256##27316470',
'setTodayTotalDetailSteps=1514038560000##7102##548579##8661##16256##27317468',
'calculateCaloriesWithCache totalCalories=128810',
'calculateAltitudeWithCache totalAltitude=240',
'REPORT : 7102 5070 152124 240',
'onStandStepChanged 3675',
'onExtend:1514038674000 1 0 4',
' getTodayTotalDetailSteps = 1514038560000##7102##548579##8661##16256##27317468',
'setTodayTotalDetailSteps=1514038560000##7103##548580##8661##16256##27318472',
'calculateCaloriesWithCache totalCalories=128831',
'calculateAltitudeWithCache totalAltitude=240',
'REPORT : 7103 5071 152146 240',
'onStandStepChanged 3676',
'onExtend:1514038675000 1 0 4',
' getTodayTotalDetailSteps = 1514038560000##7103##548580##8661##16256##27318472',
'setTodayTotalDetailSteps=1514038560000##7104##548581##8661##16256##27319473',
'calculateCaloriesWithCache totalCalories=128853',
'calculateAltitudeWithCache totalAltitude=240',
'REPORT : 7104 5072 152167 240',
'onStandStepChanged 3677',
'onExtend:1514038676000 1 0 4',
' getTodayTotalDetailSteps = 1514038560000##7104##548581##8661##16256##27319473',
'setTodayTotalDetailSteps=1514038560000##7105##548582##8661##16256##27319968',
'calculateCaloriesWithCache totalCalories=128874',
'calculateAltitudeWithCache totalAltitude=240',
'REPORT : 7105 5072 152189 240',
'onStandStepChanged 3678',
'onExtend:1514038677000 1 0 4',
' getTodayTotalDetailSteps = 1514038560000##7105##548582##8661##16256##27319968',
'setTodayTotalDetailSteps=1514038560000##7106##548583##8661##16256##27320969',
'calculateCaloriesWithCache totalCalories=128895',
'calculateAltitudeWithCache totalAltitude=240',
'REPORT : 7106 5073 152210 240',
'onStandStepChanged 3679',
'onExtend:1514038678000 1 0 4',
' getTodayTotalDetailSteps = 1514038560000##7106##548583##8661##16256##27320969',
'setTodayTotalDetailSteps=1514038560000##7107##548584##8661##16256##27321969',
'calculateCaloriesWithCache totalCalories=128917',
'calculateAltitudeWithCache totalAltitude=240',
'REPORT : 7107 5074 152231 240',
'onStandStepChanged 3681',
'onExtend:1514038678000 2 0 4',
' getTodayTotalDetailSteps = 1514038560000##7107##548584##8661##16256##27321969',
'setTodayTotalDetailSteps=1514038560000##7109##548585##8661##16256##27322469',
'calculateCaloriesWithCache totalCalories=128960',
'calculateAltitudeWithCache totalAltitude=240',
'REPORT : 7109 5075 152274 240',
'onStandStepChanged 3683',
'onExtend:1514038680000 2 0 4',
'processHandleBroadcastAction action:android.intent.action.TIME_TICK',
' getTodayTotalDetailSteps = 1514038560000##7109##548585##8661##16256##27322469',
'setTodayTotalDetailSteps=1514038620000##7111##548640##8661##16256##27324478',
'calculateCaloriesWithCache totalCalories=129002',
'calculateAltitudeWithCache totalAltitude=240',
'REPORT : 7111 5077 152317 240',
'onStandStepChanged 3684',
'onExtend:1514038682000 1 0 4',
' getTodayTotalDetailSteps = 1514038620000##7111##548640##8661##16256##27324478',
'setTodayTotalDetailSteps=1514038620000##7112##548695##8661##16256##27325968',
'calculateCaloriesWithCache totalCalories=129024',
'calculateAltitudeWithCache totalAltitude=240',
'REPORT : 7112 5077 152339 240',
'onStandStepChanged 3685',
'onExtend:1514038683000 1 0 4',
' getTodayTotalDetailSteps = 1514038620000##7112##548695##8661##16256##27325968',
'setTodayTotalDetailSteps=1514038620000##7113##548750##8661##16256##27326969',
'calculateCaloriesWithCache totalCalories=129045',
'calculateAltitudeWithCache totalAltitude=240',
'REPORT : 7113 5078 152360 240',
'onStandStepChanged 3686',
'onExtend:1514038686000 1 0 4',
' getTodayTotalDetailSteps = 1514038620000##7113##548750##8661##16256##27326969',
'setTodayTotalDetailSteps=1514038620000##7114##548805##8661##16256##27329972',
'calculateCaloriesWithCache totalCalories=129067',
'calculateAltitudeWithCache totalAltitude=240',
'REPORT : 7114 5079 152381 240',
'onStandStepChanged 3686',
'onExtend:1514038686000 0 0 0',
' getTodayTotalDetailSteps = 1514038620000##7114##548805##8661##16256##27329972',
'setTodayTotalDetailSteps=1514038620000##7114##548860##8661##16256##27330470',
'calculateCaloriesWithCache totalCalories=129067',
'calculateAltitudeWithCache totalAltitude=240',
'processHandleBroadcastAction action:android.intent.action.TIME_TICK',
'onStandStepChanged 3689',
'onExtend:1514038748000 3 0 4',
' getTodayTotalDetailSteps = 1514038620000##7114##548860##8661##16256##27330470',
'setTodayTotalDetailSteps=1514038680000##7117##548865##8661##16256##27392475',
'calculateCaloriesWithCache totalCalories=129131',
'calculateAltitudeWithCache totalAltitude=240',
'REPORT : 7117 5081 152446 240',
'onStandStepChanged 3694',
'onExtend:1514038749000 5 0 4',
' getTodayTotalDetailSteps = 1514038680000##7117##548865##8661##16256##27392475',
'setTodayTotalDetailSteps=1514038680000##7122##548870##8661##16256##27392978',
'calculateCaloriesWithCache totalCalories=129238',
'calculateAltitudeWithCache totalAltitude=240',
'REPORT : 7122 5085 152553 240',
'onStandStepChanged 3696',
'onExtend:1514038749000 2 0 4',
' getTodayTotalDetailSteps = 1514038680000##7122##548870##8661##16256##27392978',
'setTodayTotalDetailSteps=1514038680000##7124##548875##8661##16256##27393470',
'calculateCaloriesWithCache totalCalories=129281',
'calculateAltitudeWithCache totalAltitude=240',
'REPORT : 7124 5086 152596 240',
'onStandStepChanged 3698',
'onExtend:1514038750000 2 0 4',
' getTodayTotalDetailSteps = 1514038680000##7124##548875##8661##16256##27393470',
'setTodayTotalDetailSteps=1514038680000##7126##548880##8661##16256##27393971',
'calculateCaloriesWithCache totalCalories=129324',
'calculateAltitudeWithCache totalAltitude=240',
'REPORT : 7126 5087 152638 240',
'onStandStepChanged 3700',
'onExtend:1514038750000 2 0 4',
' getTodayTotalDetailSteps = 1514038680000##7126##548880##8661##16256##27393971',
'setTodayTotalDetailSteps=1514038680000##7128##548885##8661##16256##27394469',
'calculateCaloriesWithCache totalCalories=129366',
'calculateAltitudeWithCache totalAltitude=240',
'REPORT : 7128 5089 152681 240',
'onStandStepChanged 3702',
'onExtend:1514038751000 2 0 4',
' getTodayTotalDetailSteps = 1514038680000##7128##548885##8661##16256##27394469',
'setTodayTotalDetailSteps=1514038680000##7130##548890##8661##16256##27394969',
'calculateCaloriesWithCache totalCalories=129409',
'calculateAltitudeWithCache totalAltitude=240',
'REPORT : 7130 5090 152724 240',
'onStandStepChanged 3704',
'onExtend:1514038751000 2 0 4',
' getTodayTotalDetailSteps = 1514038680000##7130##548890##8661##16256##27394969',
'setTodayTotalDetailSteps=1514038680000##7132##548895##8661##16256##27395468',
'calculateCaloriesWithCache totalCalories=129452',
'calculateAltitudeWithCache totalAltitude=240',
'REPORT : 7132 5092 152767 240',
'onStandStepChanged 3707',
'onExtend:1514038752000 3 0 4',
' getTodayTotalDetailSteps = 1514038680000##7132##548895##8661##16256##27395468',
'setTodayTotalDetailSteps=1514038680000##7135##548900##8661##16256##27395969',
'calculateCaloriesWithCache totalCalories=129516',
'calculateAltitudeWithCache totalAltitude=240',
'REPORT : 7135 5094 152831 240',
'onStandStepChanged 3711',
'onExtend:1514038752000 4 0 4',
' getTodayTotalDetailSteps = 1514038680000##7135##548900##8661##16256##27395969',
'setTodayTotalDetailSteps=1514038680000##7139##548905##8661##16256##27396473',
'calculateCaloriesWithCache totalCalories=129602',
'calculateAltitudeWithCache totalAltitude=240',
'REPORT : 7139 5097 152917 240',
'onStandStepChanged 3712',
'onExtend:1514038753000 1 0 4',
' getTodayTotalDetailSteps = 1514038680000##7139##548905##8661##16256##27396473',
'setTodayTotalDetailSteps=1514038680000##7140##548910##8661##16256##27396969',
'calculateCaloriesWithCache totalCalories=129623',
'calculateAltitudeWithCache totalAltitude=240',
'REPORT : 7140 5097 152938 240',
'onStandStepChanged 3726',
'onExtend:1514038755000 14 0 4',
' getTodayTotalDetailSteps = 1514038680000##7140##548910##8661##16256##27396969',
'setTodayTotalDetailSteps=1514038680000##7154##548915##8661##16256##27398975',
'calculateCaloriesWithCache totalCalories=129923',
'calculateAltitudeWithCache totalAltitude=240',
'REPORT : 7154 5107 153238 240',
'onStandStepChanged 3726',
'onExtend:1514038756000 0 0 0',
' getTodayTotalDetailSteps = 1514038680000##7154##548915##8661##16256##27398975',
'setTodayTotalDetailSteps=1514038680000##7154##548920##8661##16256##27400475',
'calculateCaloriesWithCache totalCalories=129923',
'calculateAltitudeWithCache totalAltitude=240',
'onReceive action: android.intent.action.SCREEN_OFF',
'onStandStepChanged 3732',
'onExtend:1514038756000 6 0 4',
'onStandStepChanged 3732',
'onExtend:1514038798000 0 0 4',
'onReceive action: android.intent.action.SCREEN_ON',
'processHandleBroadcastAction action:android.intent.action.SCREEN_ON',
'flush sensor data',
' getTodayTotalDetailSteps = 1514038680000##7154##548920##8661##16256##27400475',
'setTodayTotalDetailSteps=1514038680000##7160##548925##8661##16256##27442097',
'onStandStepChanged 3732',
'calculateCaloriesWithCache totalCalories=130052',
'calculateAltitudeWithCache totalAltitude=240',
'REPORT : 7160 5112 153367 240',
'onStandStepChanged 3732',
'onExtend:1514038798000 0 0 4',
' getTodayTotalDetailSteps = 1514038680000##7160##548925##8661##16256##27442097',
'setTodayTotalDetailSteps=1514038680000##7160##548930##8661##16256##27442416',
'calculateCaloriesWithCache totalCalories=130052',
'calculateAltitudeWithCache totalAltitude=240',
'onStandStepChanged 3735',
'flushTempCacheToDB by stand',
'Alarm uploadStaticsToDB totalSteps=7163Calories:153367Floor:240Distance:5112',
'writeDataToDB size 327',
'upLoadOneMinuteDataToEngine time=25233975,0,93,0,20002',
'upLoadOneMinuteDataToEngine time=25233976,0,1,0,20002',
'upLoadOneMinuteDataToEngine time=25233977,0,55,0,20002',
'upLoadOneMinuteDataToEngine time=25233978,0,5,0,20002',
'upLoadOneMinuteDataToEngine time=25233979,0,46,0,20002',
'getBinderPackageName packageName = com.huawei.health',
'getBinderPackageName packageName = com.huawei.health',
'getAppContext() isAppValid health or wear, packageName = com.huawei.health',
'onExtend:1514038799000 3 0 4',
'getBinderPackageName packageName = com.huawei.health',
'getBinderPackageName packageName = com.huawei.health',
'insertHiHealthData() checkAppType 0 appID = 1',
'insertHiHealthData() size = 4,app = 1,One Data Type = 40002,packageName = com.huawei.health,writeStatType = 0',
'saveHealthDetailData() deviceID = 2,clientID=1,id=1',
'saveStatData() type =40002,time = 1513958400000,statClient = 2,who is 1',
'new date =20171223, type=40002,7163.0,old=6983.0',
'saveStatData() type =40003,time = 1513958400000,statClient = 2,who is 1',
'new date =20171223, type=40003,153367.0,old=210654.54000000004',
'saveHealthDetailData() saveOneDetailData fail hiHealthData = 1513958400000,type = 40003',
'saveStatData() type =40005,time = 1513958400000,statClient = 2,who is 1',
'new date =20171223, type=40005,240.0,old=330.0',
'saveHealthDetailData() saveOneDetailData fail hiHealthData = 1513958400000,type = 40005',
'saveStatData() type =40004,time = 1513958400000,statClient = 2,who is 1',
'new date =20171223, type=40004,5112.0,old=4985.0',
'bulkSaveDetailHiHealthData() size = 4,totalTime = 30',
'startListenerChange subscribeList = [1]',
'insertHiHealthData() bulkSaveDetailHiHealthData fail errorCode = 4,errorMessage = ERR_DATA_INSERT',
'insertHiHealthData() end totalTime = 45',
'uploadStaticsToDB() onResult type = 4 obj=true',
'uploadStaticsToDB failed message=true',
'checkInsertStatus stepSum or calorieSum is enough',
'getBinderPackageName packageName = com.huawei.health',
'getBinderPackageName packageName = com.huawei.health',
'getAppContext() isAppValid health or wear, packageName = com.huawei.health',
'checkInsertStatus stepStatSum or calorieStatSum is enough',
'stepSyncOrNot appSynTimes is 0, statsyncTimes is 0',
'startInsertSportSync start auto sync,app is 1',
'getBinderPackageName packageName = com.huawei.health',
'checkFirstSyncByType no such data in db ,type is 1 deviceCode is 0',
'startInsertSportSync first 500 steps sync,do all sync',
'getBinderPackageName packageName = com.huawei.health',
'startSync hiSyncOption = HiSyncOption{syncAction=2, syncMethod=2, syncScope=0, syncDataType=20000, syncModel=2, pushAction=0},app = 1 who = 1',
'insertHiHealthData() checkAppType 0 appID = 1',
'insertHiHealthData() size = 20,app = 1,One Data Type = 2,packageName = com.huawei.health,writeStatType = 0',
'needAutoSync autoSyncSwitch is open',
'saveHealthDetailData() deviceID = 2,clientID=1,id=1',
'initDataPrivacy the dataPrivacy switch is open, start push health data!',
'initDataPrivacy the dataPrivacy is true',
'initUserPrivacy the userPrivacy switch is open, start push user data!',
'initUserPrivacy the userPrivacy is true',
'ifCanSync not! no cloud version',
'sendSyncFailedBroadcast',
'bulkSaveDetailHiHealthData() size = 20,totalTime = 34',
'new date =20171223, type=40002,6724.0,old=7163.0',
'new date =20171223, type=40004,4800.935999999999,old=5112.0',
'new date =20171223, type=40003,214445.88000000006,old=210654.54000000004',
'new date =20171223, type=40005,330.0,old=330.0',
'new date =20171223, type=40011,6314.0,old=6137.0',
'new date =20171223, type=40031,4508.196000000001,old=4381.818',
'new date =20171223, type=40021,135245.88,old=131454.53999999995',
'new date =20171223, type=40013,410.0,old=410.0',
'new date =20171223, type=40034,292.73999999999995,old=292.73999999999995',
'new date =20171223, type=40024,79200.0,old=79200.0',
'new date =20171223, type=40041,6720.0,old=6480.0',
'new date =20171223, type=40044,420.0,old=420.0',
'new date =20171223, type=40006,7140.0,old=6900.0',
'saveRealTimeHealthDatasStat() size = 1,totalTime = 48',
'startListenerChange subscribeList = [1]',
'insertHiHealthData() end totalTime = 94',
'InsertCallBack() onSuccess type = 0 data=true',
'InsertEvent success begin:25233975 end:25233979',
'setWriteDBLastDataMinute=25233979',
'setWriteDBLastDataMinute success',
'flush2DB result success',
' getTodayTotalDetailSteps = 1514038680000##7160##548930##8661##16256##27442416',
'setTodayTotalDetailSteps=1514038680000##7163##548935##8661##16256##27442827',
'checkInsertStatus stepSum or calorieSum is enough',
'calculateCaloriesWithCache totalCalories=130116',
'checkInsertStatus stepStatSum or calorieStatSum is enough',
'stepSyncOrNot appSynTimes is 0, statsyncTimes is 0',
'startInsertSportSync start auto sync,app is 1',
'checkFirstSyncByType no such data in db ,type is 1 deviceCode is 0',
'startInsertSportSync first 500 steps sync,do all sync',
'startSync hiSyncOption = HiSyncOption{syncAction=2, syncMethod=2, syncScope=0, syncDataType=20000, syncModel=2, pushAction=0},app = 1 who = 1',
'needAutoSync autoSyncSwitch is open',
'calculateAltitudeWithCache totalAltitude=240',
'initDataPrivacy the dataPrivacy switch is open, start push health data!',
'initDataPrivacy the dataPrivacy is true',
'initUserPrivacy the userPrivacy switch is open, start push user data!',
'initUserPrivacy the userPrivacy is true',
'ifCanSync not! no cloud version',
'sendSyncFailedBroadcast',
'REPORT : 7163 5114 153431 240',
'onStandStepChanged 3737',
'onExtend:1514038799000 2 0 4',
' getTodayTotalDetailSteps = 1514038680000##7163##548935##8661##16256##27442827',
'setTodayTotalDetailSteps=1514038680000##7165##548940##8661##16256##27443484',
'calculateCaloriesWithCache totalCalories=130159',
'calculateAltitudeWithCache totalAltitude=240',
'REPORT : 7165 5115 153474 240',
'onStandStepChanged 3739',
'onExtend:1514038800000 2 0 4',
' getTodayTotalDetailSteps = 1514038680000##7165##548940##8661##16256##27443484',
'setTodayTotalDetailSteps=1514038680000##7167##548945##8661##16256##27443986',
'calculateCaloriesWithCache totalCalories=130201',
'calculateAltitudeWithCache totalAltitude=240',
'REPORT : 7167 5117 153517 240',
'onStandStepChanged 3742',
'onExtend:1514038800000 3 0 4',
'processHandleBroadcastAction action:android.intent.action.TIME_TICK',
' getTodayTotalDetailSteps = 1514038680000##7167##548945##8661##16256##27443986',
'setTodayTotalDetailSteps=1514038740000##7170##548996##8661##16256##27444484',
'calculateCaloriesWithCache totalCalories=130266',
'calculateAltitudeWithCache totalAltitude=240',
'REPORT : 7170 5119 153581 240',
'onStandStepChanged 3745',
'onExtend:1514038801000 3 0 4',
' getTodayTotalDetailSteps = 1514038740000##7170##548996##8661##16256##27444484',
'setTodayTotalDetailSteps=1514038740000##7173##549047##8661##16256##27444985',
'calculateCaloriesWithCache totalCalories=130330',
'calculateAltitudeWithCache totalAltitude=240',
'REPORT : 7173 5121 153645 240',
'onStandStepChanged 3746',
'onExtend:1514038801000 1 0 4',
' getTodayTotalDetailSteps = 1514038740000##7173##549047##8661##16256##27444985',
'setTodayTotalDetailSteps=1514038740000##7174##549098##8661##16256##27445485',
'calculateCaloriesWithCache totalCalories=130351',
'calculateAltitudeWithCache totalAltitude=240',
'REPORT : 7174 5122 153667 240',
'onStandStepChanged 3748',
'onExtend:1514038802000 2 0 4',
' getTodayTotalDetailSteps = 1514038740000##7174##549098##8661##16256##27445485',
'setTodayTotalDetailSteps=1514038740000##7176##549149##8661##16256##27445983',
'calculateCaloriesWithCache totalCalories=130394',
'calculateAltitudeWithCache totalAltitude=240',
'REPORT : 7176 5123 153709 240',
'onStandStepChanged 3751',
'onExtend:1514038802000 3 0 4',
' getTodayTotalDetailSteps = 1514038740000##7176##549149##8661##16256##27445983',
'setTodayTotalDetailSteps=1514038740000##7179##549200##8661##16256##27446483',
'calculateCaloriesWithCache totalCalories=130458',
'calculateAltitudeWithCache totalAltitude=240',
'REPORT : 7179 5125 153774 240',
'onStandStepChanged 3753',
'onExtend:1514038803000 2 0 4',
' getTodayTotalDetailSteps = 1514038740000##7179##549200##8661##16256##27446483',
'setTodayTotalDetailSteps=1514038740000##7181##549251##8661##16256##27446989',
'calculateCaloriesWithCache totalCalories=130501',
'calculateAltitudeWithCache totalAltitude=240',
'REPORT : 7181 5127 153817 240',
'onStandStepChanged 3755',
'onExtend:1514038803000 2 0 4',
' getTodayTotalDetailSteps = 1514038740000##7181##549251##8661##16256##27446989',
'setTodayTotalDetailSteps=1514038740000##7183##549302##8661##16256##27447483',
'calculateCaloriesWithCache totalCalories=130544',
'calculateAltitudeWithCache totalAltitude=240',
'REPORT : 7183 5128 153859 240',
'onStandStepChanged 3757',
'onExtend:1514038804000 2 0 4',
' getTodayTotalDetailSteps = 1514038740000##7183##549302##8661##16256##27447483',
'setTodayTotalDetailSteps=1514038740000##7185##549353##8661##16256##27448486',
'calculateCaloriesWithCache totalCalories=130587',
'calculateAltitudeWithCache totalAltitude=240',
'REPORT : 7185 5130 153902 240',
'onStandStepChanged 3758',
'onExtend:1514038805000 1 0 4',
' getTodayTotalDetailSteps = 1514038740000##7185##549353##8661##16256##27448486',
'setTodayTotalDetailSteps=1514038740000##7186##549404##8661##16256##27448983',
'calculateCaloriesWithCache totalCalories=130608',
'calculateAltitudeWithCache totalAltitude=240',
'REPORT : 7186 5130 153924 240',
'onStandStepChanged 3759',
'onExtend:1514038806000 1 0 4',
' getTodayTotalDetailSteps = 1514038740000##7186##549404##8661##16256##27448983',
'setTodayTotalDetailSteps=1514038740000##7187##549455##8661##16256##27449982',
'calculateCaloriesWithCache totalCalories=130630',
'calculateAltitudeWithCache totalAltitude=240',
'REPORT : 7187 5131 153945 240',
'onStandStepChanged 3760',
'onExtend:1514038808000 1 0 4',
' getTodayTotalDetailSteps = 1514038740000##7187##549455##8661##16256##27449982',
'setTodayTotalDetailSteps=1514038740000##7188##549506##8661##16256##27451985',
'calculateCaloriesWithCache totalCalories=130651',
'calculateAltitudeWithCache totalAltitude=240',
'REPORT : 7188 5132 153966 240',
'onStandStepChanged 3761',
'onExtend:1514038808000 1 0 4',
' getTodayTotalDetailSteps = 1514038740000##7188##549506##8661##16256##27451985',
'setTodayTotalDetailSteps=1514038740000##7189##549557##8661##16256##27452491',
'calculateCaloriesWithCache totalCalories=130673',
'calculateAltitudeWithCache totalAltitude=240',
'REPORT : 7189 5132 153988 240',
'onStandStepChanged 3761',
'onExtend:1514038813000 0 0 0',
' getTodayTotalDetailSteps = 1514038740000##7189##549557##8661##16256##27452491',
'setTodayTotalDetailSteps=1514038740000##7189##549608##8661##16256##27457484',
'calculateCaloriesWithCache totalCalories=130673',
'calculateAltitudeWithCache totalAltitude=240',
'onStandStepChanged 3761',
'onExtend:1514038816000 0 0 5',
' getTodayTotalDetailSteps = 1514038740000##7189##549608##8661##16256##27457484',
'setTodayTotalDetailSteps=1514038740000##7189##549659##8661##16256##27460494',
'calculateCaloriesWithCache totalCalories=130673',
'calculateAltitudeWithCache totalAltitude=240',
'onReceive action: android.intent.action.SCREEN_OFF',
'processHandleBroadcastAction action:android.intent.action.TIME_TICK',
'processHandleBroadcastAction action:android.intent.action.TIME_TICK',
'onStandStepChanged 3761',
'onExtend:1514038819000 0 0 5',
'onExtend:1514038879000 0 0 5',
'onExtend:1514038939000 0 0 5',
'onExtend:1514038999000 0 0 5',
'onExtend:1514039059000 0 0 0',
'onReceive action: android.intent.action.SCREEN_ON',
'processHandleBroadcastAction action:android.intent.action.SCREEN_ON',
'flush sensor data',
' getTodayTotalDetailSteps = 1514038740000##7189##549659##8661##16256##27460494',
'setTodayTotalDetailSteps=1514038980000##7189##549659##8661##16256##27706526',
'onStandStepChanged 3761',
'calculateCaloriesWithCache totalCalories=130673',
'calculateAltitudeWithCache totalAltitude=240',
'REPORT : 7189 5132 153988 240',
'onStandStepChanged 3761',
'onExtend:1514039062000 0 0 0',
'processHandleBroadcastAction action:android.intent.action.TIME_TICK',
' getTodayTotalDetailSteps = 1514038980000##7189##549659##8661##16256##27706526',
'setTodayTotalDetailSteps=1514038980000##7189##549659##8661##16256##27706835',
'calculateCaloriesWithCache totalCalories=130673',
'calculateAltitudeWithCache totalAltitude=240',
'onStandStepChanged 3761',
'onExtend:1514039091000 0 0 5',
' getTodayTotalDetailSteps = 1514038980000##7189##549659##8661##16256##27706835',
'setTodayTotalDetailSteps=1514038980000##7189##549659##8661##16256##27736503',
'calculateCaloriesWithCache totalCalories=130673',
'calculateAltitudeWithCache totalAltitude=240',
'onStandStepChanged 3761',
'onExtend:1514039093000 0 0 0',
' getTodayTotalDetailSteps = 1514038980000##7189##549659##8661##16256##27736503',
'setTodayTotalDetailSteps=1514038980000##7189##549659##8661##16256##27738504',
'calculateCaloriesWithCache totalCalories=130673',
'calculateAltitudeWithCache totalAltitude=240',
'onStandStepChanged 3761',
'onExtend:1514039098000 0 0 5',
' getTodayTotalDetailSteps = 1514038980000##7189##549659##8661##16256##27738504',
'setTodayTotalDetailSteps=1514038980000##7189##549659##8661##16256##27743510',
'calculateCaloriesWithCache totalCalories=130673',
'calculateAltitudeWithCache totalAltitude=240',
'processHandleBroadcastAction action:android.intent.action.TIME_TICK',
'onReceive action: android.intent.action.SCREEN_OFF',
'processHandleBroadcastAction action:android.intent.action.TIME_TICK',
'processHandleBroadcastAction action:android.intent.action.TIME_TICK',
'processHandleBroadcastAction action:android.intent.action.TIME_TICK',
'onStandStepChanged 3761',
'onExtend:1514039112000 0 0 5',
'onExtend:1514039172000 0 0 5',
'onExtend:1514039232000 0 0 5',
'onExtend:1514039292000 0 0 5',
'onExtend:1514039352000 0 0 5',
'onExtend:1514039412000 0 0 0',
'onReceive action: android.intent.action.SCREEN_ON',
'processHandleBroadcastAction action:android.intent.action.SCREEN_ON',
'flush sensor data',
' getTodayTotalDetailSteps = 1514038980000##7189##549659##8661##16256##27743510',
'setTodayTotalDetailSteps=1514039340000##7189##549659##8661##16256##28068346',
'onStandStepChanged 3761',
'calculateCaloriesWithCache totalCalories=130673',
'calculateAltitudeWithCache totalAltitude=240',
'REPORT : 7189 5132 153988 240',
'onStandStepChanged 3761',
'onExtend:1514039424000 0 0 0',
' getTodayTotalDetailSteps = 1514039340000##7189##549659##8661##16256##28068346',
'setTodayTotalDetailSteps=1514039340000##7189##549659##8661##16256##28068666',
'calculateCaloriesWithCache totalCalories=130673',
'calculateAltitudeWithCache totalAltitude=240',
'processHandleBroadcastAction action:android.intent.action.TIME_TICK',
'onStandStepChanged 3761',
'onExtend:1514039492000 0 0 5',
' getTodayTotalDetailSteps = 1514039340000##7189##549659##8661##16256##28068666',
'setTodayTotalDetailSteps=1514039400000##7189##549659##8661##16256##28136544',
'calculateCaloriesWithCache totalCalories=130673',
'calculateAltitudeWithCache totalAltitude=240',
'onReceive action: android.intent.action.SCREEN_OFF',
'onStandStepChanged 3761',
'onReceive action: android.intent.action.SCREEN_ON',
'processHandleBroadcastAction action:android.intent.action.SCREEN_ON',
'flush sensor data',
'onExtend:1514039515000 0 0 0',
'onExtend:1514039575000 0 0 0',
' getTodayTotalDetailSteps = 1514039400000##7189##549659##8661##16256##28136544',
'setTodayTotalDetailSteps=1514039400000##7189##549659##8661##16256##28163940',
'onStandStepChanged 3761',
'calculateCaloriesWithCache totalCalories=130673',
'calculateAltitudeWithCache totalAltitude=240',
'REPORT : 7189 5132 153988 240',
'onStandStepChanged 3761',
'onExtend:1514039520000 0 0 0',
'timeStamp back,extendReportTimeStamp=1514039575000',
...]
file1['Con'] =file1['Content'].str.split('=').str.get(0)
file1['Con_log'] =file1['Content'].str.split('=').str.get(1)
file1['mix'] = file1['Content'].str.split('total').str.get(1)
file2 = file1[~file1['mix'].isnull()]
file2['mix1'] = file2['mix'].str.split('=').str.get(0)
file2['value'] = file2['mix'].str.split('=').str.get(1)
C:\Users\Dell\AppData\Local\Temp\ipykernel_18384\317096185.py:1: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
file2['mix1'] = file2['mix'].str.split('=').str.get(0)
C:\Users\Dell\AppData\Local\Temp\ipykernel_18384\317096185.py:2: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
file2['value'] = file2['mix'].str.split('=').str.get(1)
file3 = file2[file2['mix1']=='Calories']
file4 = file3.drop(['Content','Con','mix','EventTemplate','Con_log'], axis=1)
file5 = file4.reset_index().drop(['index'], axis=1)
print(file5[['hour', 'minutes', 'seconds']].isnull().any())
hour False minutes False seconds False dtype: bool
file5['value'] = pd.to_numeric(file5['value'])
file5['year'] = pd.to_numeric(file5['year'])
file5['month'] = pd.to_numeric(file5['month'])
file5['day'] = pd.to_numeric(file5['day'])
#file5['week'] = pd.to_numeric(file5['week'])
file5['hour'] = pd.to_numeric(file5['hour'])
file5['seconds'] = pd.to_numeric(file5['seconds'])
file5['minutes'] = pd.to_numeric(file5['minutes'])
file5.info()
<class 'pandas.core.frame.DataFrame'> RangeIndex: 241 entries, 0 to 240 Data columns (total 14 columns): # Column Non-Null Count Dtype --- ------ -------------- ----- 0 LineId 241 non-null int64 1 Time 241 non-null object 2 Component 241 non-null object 3 Pid 241 non-null int64 4 EventId 241 non-null object 5 year 241 non-null int32 6 month 241 non-null int32 7 day 241 non-null int32 8 hour 241 non-null int64 9 minutes 241 non-null int64 10 seconds 241 non-null int64 11 hour_minute 241 non-null object 12 mix1 241 non-null object 13 value 241 non-null int64 dtypes: int32(3), int64(6), object(5) memory usage: 23.7+ KB
file6 = file5.drop(['Pid','LineId','Time','EventId'], axis=1)
file6
| Component | year | month | day | hour | minutes | seconds | hour_minute | mix1 | value | |
|---|---|---|---|---|---|---|---|---|---|---|
| 0 | Step_ExtSDM | 2017 | 12 | 23 | 22 | 15 | 29 | 22:15 | Calories | 126775 |
| 1 | Step_ExtSDM | 2017 | 12 | 23 | 22 | 15 | 29 | 22:15 | Calories | 126797 |
| 2 | Step_ExtSDM | 2017 | 12 | 23 | 22 | 15 | 30 | 22:15 | Calories | 126818 |
| 3 | Step_ExtSDM | 2017 | 12 | 23 | 22 | 15 | 31 | 22:15 | Calories | 126861 |
| 4 | Step_ExtSDM | 2017 | 12 | 23 | 22 | 15 | 32 | 22:15 | Calories | 126882 |
| ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... |
| 236 | Step_ExtSDM | 2017 | 12 | 24 | 0 | 11 | 57 | 00:11 | Calories | 0 |
| 237 | Step_ExtSDM | 2017 | 12 | 24 | 0 | 15 | 53 | 00:15 | Calories | 0 |
| 238 | Step_ExtSDM | 2017 | 12 | 24 | 0 | 25 | 16 | 00:25 | Calories | 0 |
| 239 | Step_ExtSDM | 2017 | 12 | 24 | 0 | 25 | 17 | 00:25 | Calories | 0 |
| 240 | Step_ExtSDM | 2017 | 12 | 24 | 0 | 28 | 25 | 00:28 | Calories | 0 |
241 rows × 10 columns
file6['cal_Burned'] = file6['value'].diff()
file6['cal_Burned'].loc[217] = 0
C:\Users\Dell\AppData\Local\Temp\ipykernel_18384\3208568987.py:1: SettingWithCopyWarning: A value is trying to be set on a copy of a slice from a DataFrame See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy file6['cal_Burned'].loc[217] = 0
file6['cumulative_cal_Burned'] = file6['cal_Burned'].cumsum()
file6
| Component | year | month | day | hour | minutes | seconds | hour_minute | mix1 | value | cal_Burned | cumulative_cal_Burned | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | Step_ExtSDM | 2017 | 12 | 23 | 22 | 15 | 29 | 22:15 | Calories | 126775 | NaN | NaN |
| 1 | Step_ExtSDM | 2017 | 12 | 23 | 22 | 15 | 29 | 22:15 | Calories | 126797 | 22.0 | 22.0 |
| 2 | Step_ExtSDM | 2017 | 12 | 23 | 22 | 15 | 30 | 22:15 | Calories | 126818 | 21.0 | 43.0 |
| 3 | Step_ExtSDM | 2017 | 12 | 23 | 22 | 15 | 31 | 22:15 | Calories | 126861 | 43.0 | 86.0 |
| 4 | Step_ExtSDM | 2017 | 12 | 23 | 22 | 15 | 32 | 22:15 | Calories | 126882 | 21.0 | 107.0 |
| ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... |
| 236 | Step_ExtSDM | 2017 | 12 | 24 | 0 | 11 | 57 | 00:11 | Calories | 0 | 0.0 | 4433.0 |
| 237 | Step_ExtSDM | 2017 | 12 | 24 | 0 | 15 | 53 | 00:15 | Calories | 0 | 0.0 | 4433.0 |
| 238 | Step_ExtSDM | 2017 | 12 | 24 | 0 | 25 | 16 | 00:25 | Calories | 0 | 0.0 | 4433.0 |
| 239 | Step_ExtSDM | 2017 | 12 | 24 | 0 | 25 | 17 | 00:25 | Calories | 0 | 0.0 | 4433.0 |
| 240 | Step_ExtSDM | 2017 | 12 | 24 | 0 | 28 | 25 | 00:28 | Calories | 0 | 0.0 | 4433.0 |
241 rows × 12 columns
time_str1 = '22:15'
time_str2 = '00:28'
datetime1 = datetime.strptime(time_str1, '%H:%M')
datetime2 = datetime.strptime(time_str2, '%H:%M')
time_difference = datetime2 - datetime1
time_difference
datetime.timedelta(days=-1, seconds=7980)
# this whole analysis is going to be of 7980 seconds or 2 hours,13 minutes
df = pd.DataFrame()
df['index'] = file6['hour_minute']
df['cumulative_cal_Burned'] = file6['cumulative_cal_Burned']
df = df.set_index('index')
df['cumulative_cal_Burned'].plot(kind='line')
plt.grid(True)
# total Calories burned by person is around 4433.0 in 2 hour and 13 minutes
fig = go.Figure()
fig.add_trace(go.Scatter(
x=file6['cumulative_cal_Burned'],
y=file6['hour_minute'],
mode='markers',
marker=dict(size=8),
))
fig.update_layout(
title='Scatter Plot of Cumulative Calories Burned',
xaxis=dict(title='Cumulative Calories Burned'),
yaxis=dict(title='Hour Minute'),
)
fig.show()
# as per above graph, the person has burned around 1371 calories which lap was around 2:00 mintues
# in second lap, after break person has burned 921 calories and lap was around 2.00
df1 = pd.DataFrame()
df1['index'] = file6['hour_minute']
df1['cal_Burned'] = file6['cal_Burned']
df1 = df1.set_index('index')
df1['cal_Burned'].plot(kind='line')
plt.grid(True)
# there is fluctuation in Calories burn, it could be due to running fast and slow # as you can see around 22.17 to 20:19, there is highest rate of Calories burn, may be person must be running fast # in other cases, he must be running slow # sometime it was 0, person must have stop running
file6['value'].plot()
<Axes: >
# as per old history person have burned 126775 before 22.15
file6
| Component | year | month | day | hour | minutes | seconds | hour_minute | mix1 | value | cal_Burned | cumulative_cal_Burned | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | Step_ExtSDM | 2017 | 12 | 23 | 22 | 15 | 29 | 22:15 | Calories | 126775 | NaN | NaN |
| 1 | Step_ExtSDM | 2017 | 12 | 23 | 22 | 15 | 29 | 22:15 | Calories | 126797 | 22.0 | 22.0 |
| 2 | Step_ExtSDM | 2017 | 12 | 23 | 22 | 15 | 30 | 22:15 | Calories | 126818 | 21.0 | 43.0 |
| 3 | Step_ExtSDM | 2017 | 12 | 23 | 22 | 15 | 31 | 22:15 | Calories | 126861 | 43.0 | 86.0 |
| 4 | Step_ExtSDM | 2017 | 12 | 23 | 22 | 15 | 32 | 22:15 | Calories | 126882 | 21.0 | 107.0 |
| ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... |
| 236 | Step_ExtSDM | 2017 | 12 | 24 | 0 | 11 | 57 | 00:11 | Calories | 0 | 0.0 | 4433.0 |
| 237 | Step_ExtSDM | 2017 | 12 | 24 | 0 | 15 | 53 | 00:15 | Calories | 0 | 0.0 | 4433.0 |
| 238 | Step_ExtSDM | 2017 | 12 | 24 | 0 | 25 | 16 | 00:25 | Calories | 0 | 0.0 | 4433.0 |
| 239 | Step_ExtSDM | 2017 | 12 | 24 | 0 | 25 | 17 | 00:25 | Calories | 0 | 0.0 | 4433.0 |
| 240 | Step_ExtSDM | 2017 | 12 | 24 | 0 | 28 | 25 | 00:28 | Calories | 0 | 0.0 | 4433.0 |
241 rows × 12 columns
fd = pd.DataFrame()
fd
fd['hour'] = file6['hour']
fd['minutes'] = file6['minutes']
fd['seconds'] = file6['seconds']
fd['cal_Burned'] = file6['cal_Burned']
fd['cumulative_cal_Burned'] = file6['cumulative_cal_Burned']
fd
| hour | minutes | seconds | cal_Burned | cumulative_cal_Burned | |
|---|---|---|---|---|---|
| 0 | 22 | 15 | 29 | NaN | NaN |
| 1 | 22 | 15 | 29 | 22.0 | 22.0 |
| 2 | 22 | 15 | 30 | 21.0 | 43.0 |
| 3 | 22 | 15 | 31 | 43.0 | 86.0 |
| 4 | 22 | 15 | 32 | 21.0 | 107.0 |
| ... | ... | ... | ... | ... | ... |
| 236 | 0 | 11 | 57 | 0.0 | 4433.0 |
| 237 | 0 | 15 | 53 | 0.0 | 4433.0 |
| 238 | 0 | 25 | 16 | 0.0 | 4433.0 |
| 239 | 0 | 25 | 17 | 0.0 | 4433.0 |
| 240 | 0 | 28 | 25 | 0.0 | 4433.0 |
241 rows × 5 columns
fd['hourtime'] = fd['hour'].astype(str) + ':' + fd['minutes'].astype(str) + ':' + fd['minutes'].astype(str)
first_lap = fd[(fd['minutes'] <= 17) & (fd['cumulative_cal_Burned'] <= 1371)]
first_lap.head()
| hour | minutes | seconds | cal_Burned | cumulative_cal_Burned | hourtime | |
|---|---|---|---|---|---|---|
| 1 | 22 | 15 | 29 | 22.0 | 22.0 | 22:15:15 |
| 2 | 22 | 15 | 30 | 21.0 | 43.0 | 22:15:15 |
| 3 | 22 | 15 | 31 | 43.0 | 86.0 | 22:15:15 |
| 4 | 22 | 15 | 32 | 21.0 | 107.0 | 22:15:15 |
| 5 | 22 | 15 | 32 | 22.0 | 129.0 | 22:15:15 |
fig = go.Figure()
fig.add_trace(go.Scatter(
x=first_lap['cumulative_cal_Burned'],
y=first_lap['hourtime'],
mode='markers',
marker=dict(size=8),
))
fig.update_layout(
title='Scatter Plot of Cumulative Calories Burned',
xaxis=dict(title='Cumulative Calories Burned'),
yaxis=dict(title='Hour Minute'),
)
fig.show()
second_lap = fd[(fd['cumulative_cal_Burned'] <= 2356) & (fd['cumulative_cal_Burned'] > 1371)]
second_lap
| hour | minutes | seconds | cal_Burned | cumulative_cal_Burned | hourtime | |
|---|---|---|---|---|---|---|
| 54 | 22 | 17 | 25 | 64.0 | 1435.0 | 22:17:17 |
| 55 | 22 | 17 | 28 | 0.0 | 1435.0 | 22:17:17 |
| 56 | 22 | 17 | 45 | 21.0 | 1456.0 | 22:17:17 |
| 57 | 22 | 17 | 45 | 43.0 | 1499.0 | 22:17:17 |
| 58 | 22 | 17 | 46 | 43.0 | 1542.0 | 22:17:17 |
| 59 | 22 | 17 | 46 | 43.0 | 1585.0 | 22:17:17 |
| 60 | 22 | 17 | 47 | 43.0 | 1628.0 | 22:17:17 |
| 61 | 22 | 17 | 47 | 21.0 | 1649.0 | 22:17:17 |
| 62 | 22 | 17 | 48 | 43.0 | 1692.0 | 22:17:17 |
| 63 | 22 | 17 | 48 | 43.0 | 1735.0 | 22:17:17 |
| 64 | 22 | 17 | 49 | 43.0 | 1778.0 | 22:17:17 |
| 65 | 22 | 17 | 49 | 42.0 | 1820.0 | 22:17:17 |
| 66 | 22 | 17 | 50 | 43.0 | 1863.0 | 22:17:17 |
| 67 | 22 | 17 | 50 | 22.0 | 1885.0 | 22:17:17 |
| 68 | 22 | 17 | 51 | 43.0 | 1928.0 | 22:17:17 |
| 69 | 22 | 17 | 51 | 42.0 | 1970.0 | 22:17:17 |
| 70 | 22 | 17 | 52 | 43.0 | 2013.0 | 22:17:17 |
| 71 | 22 | 17 | 53 | 22.0 | 2035.0 | 22:17:17 |
| 72 | 22 | 17 | 54 | 21.0 | 2056.0 | 22:17:17 |
| 73 | 22 | 17 | 55 | 22.0 | 2078.0 | 22:17:17 |
| 74 | 22 | 17 | 55 | 21.0 | 2099.0 | 22:17:17 |
| 75 | 22 | 17 | 56 | 21.0 | 2120.0 | 22:17:17 |
| 76 | 22 | 17 | 57 | 22.0 | 2142.0 | 22:17:17 |
| 77 | 22 | 17 | 58 | 43.0 | 2185.0 | 22:17:17 |
| 78 | 22 | 18 | 0 | 42.0 | 2227.0 | 22:18:18 |
| 79 | 22 | 18 | 1 | 22.0 | 2249.0 | 22:18:18 |
| 80 | 22 | 18 | 2 | 21.0 | 2270.0 | 22:18:18 |
| 81 | 22 | 18 | 5 | 22.0 | 2292.0 | 22:18:18 |
| 82 | 22 | 18 | 6 | 0.0 | 2292.0 | 22:18:18 |
| 83 | 22 | 19 | 8 | 64.0 | 2356.0 | 22:19:19 |
fig = go.Figure()
fig.add_trace(go.Scatter(
x=second_lap['cumulative_cal_Burned'],
y=second_lap['hourtime'],
mode='markers',
marker=dict(size=8),
))
fig.update_layout(
title='Scatter Plot of Cumulative Calories Burned',
xaxis=dict(title='Cumulative Calories Burned'),
yaxis=dict(title='Hour Minute'),
)
fig.show()
1. During the second lap person burned around 921 calories in which in the first minute person has burned around
750 calories in the next minute during the second lap he has burned only 171 calories.The rate of calorie burn in
the second minute of second lap reduced by 77.2 percent.
third_lap = fd[fd['cumulative_cal_Burned'] > 2356]
fig = go.Figure()
fig.add_trace(go.Scatter(
x=third_lap['cumulative_cal_Burned'],
y=third_lap['hourtime'],
mode='markers',
marker=dict(size=8),
))
fig.update_layout(
title='Scatter Plot of Cumulative Calories Burned',
xaxis=dict(title='Cumulative Calories Burned'),
yaxis=dict(title='Hour Minute'),
)
fig.show()
1. During the third lap person burned around 1970 calories in the first minute person has burned around
1435 calories in the second minute during the third lap he has burned only 535 calories.The rate of calorie burn in
the second minute of third lap reduced by 62.71 percent.
Title: "Comprehensive Fitness Analysis: Unveiling Caloric Expenditure Patterns Over 2 Hours and 13 Minutes"
In the span of 7980 seconds, equivalent to 2 hours and 13 minutes, a detailed examination of the fitness analytics reveals intriguing insights. According to the graphical representation, the individual expended approximately 1371 calories in a lap lasting around 2:00 minutes.
Notably, in the second lap, following a brief break, the caloric burn reached 921 calories within a 2-minute span. The data suggests fluctuations in caloric expenditure, potentially attributed to variations in running pace—highlighted prominently between 22:17 and 20:19, indicating a period of heightened caloric burn, possibly indicative of vigorous running. Conversely, instances of zero caloric burn suggest moments of halted running.
A closer look at the second lap unveils a significant reduction in calorie burn rate, dropping by 77.2 percent from 750 calories in the first minute to 171 calories in the subsequent minute. Similarly, in the third lap, despite an overall caloric expenditure of 1970 calories, there was a 62.71 percent reduction in the calorie burn rate between the first and second minutes, from 1435 to 535 calories.
This comprehensive analysis not only sheds light on the overall caloric burn but also dissects minute-by-minute trends, offering valuable insights into the individual's varying running intensities and potential periods of rest.